Cube Yogi
Cube Yogi
Leader in Zoho Solutions/Consultation

Update formatted address in newly created multi line field

Here is our approach to update formatted address in newly created multi line field

Our Assumption 

1. We assume that you have want to create one multi line field

2. Also you have one address field with street in some module. As an example, we've taken the Contacts module

Approach 

We've given the steps to update formatted address in newly created multi line field

1. Adding new multi line field in Contacts module

1.1  Go to "Contacts" and go to any entry

1.2 Tap on "Edit"

1.3 Tap on "Edit Page Layout"

1.4 Drag the multi line field to the section you wanted

1.5 Give field name as mentioned in the image and save

2. Finding  API name for required fields in Leads & Contacts module 

2.1 Tap on Settings icon

2.2 Tap on "APIs" under DEVELOPER SPACE 

2.3 Tap on "API Names"

2.4 Tap on  "Contacts"

2.5 Find the required  fields' API Names, copy and paste it in the corresponding  line 

3. Create workflow to  update multi line field

3.1 Tap on settings icon

3.2 Tap on "Workflow Rules" 

3.3 Tap on Create Rule

3.4 Give values as mentioned in the image and create rule

3.5 Give conditions as mentioned in the image

3.6 Choose "All Contacts"

3.7 Choose function as action

3.8 Tap on New Function

3.9 Choose Write your own

3.10 Create function as mentioned in the below image

3.11 Tap on "Edit Arguments"

3.12 Choose the following  as mentioned in the image to configure argument

3.13 Copy and paste the code in Code Snippet and tap on Save

3.14 Tap on "Save" 

Code Snippet 

Related Community Question

Use Formula Field to grab Address minus street number | Link

I need to create a Field that uses a formula to take regular Address "123 Main Street" and removes the numbers from the front and makes it "Main Street" only.

Sample Data:
123 Main Street (becomes "Main Street")
444 Count Rd (becomes "Count Rd")
543 Number Avenue #2  (becomes "Number Ave #2")

How do I do this?